UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eFYrr0idA/cSbk9Fub4zBh1pA00LjK7GHu0OGIyCgek='
WHERE
key_id = 'c16e7c36056c3ae927baae77486fcc939ad7437bd7e46aa73463058ea2f6a82a'
AND (
token = 'eFYrr0idA/cSbk9Fub4zBh1pA00LjK7GHu0OGIyCgek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)