UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5QPbZFcB+BVMu+oI6jp+/8wMdM24JyZg/74CUdI9y98='
WHERE
key_id = 'ef35bad87742477a0e3ec4ead829616aa2b34a31c8d3abf33ee1e9aafc6fa985'
AND (
token = '5QPbZFcB+BVMu+oI6jp+/8wMdM24JyZg/74CUdI9y98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)