UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rKMMnYIzNref/YWzoPw6pDUoEIE3YwdSsw8RKnYiQy0='
WHERE
key_id = '0ca687e35b51fdf4ce9faddd95c1bd941fc33ad574f92434ece23780b27e7305'
AND (
token = 'rKMMnYIzNref/YWzoPw6pDUoEIE3YwdSsw8RKnYiQy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)