UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qzsd2BkVhTJWf1EeXFFEfIk64a4NRW+ybr5cYPKsNtE='
WHERE
key_id = '6ae754545d4d96ba669164a55dec60d4d406bcdfa2bd616dfd4b7b68386df38d'
AND (
token = 'Qzsd2BkVhTJWf1EeXFFEfIk64a4NRW+ybr5cYPKsNtE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)