UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7swXnMSs7QQhUjahDPkm5RN02IKxaBzcfi4zczHmFJ8='
WHERE
key_id = 'be8ab3299b0415bc81e1c5d2f64afbeffef10040e4eb0b545b75cb9e0d646542'
AND (
token = '7swXnMSs7QQhUjahDPkm5RN02IKxaBzcfi4zczHmFJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)