UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zbCTkbEfulOWXo2q249bpGb3T2MParuTh4skBZkNUGE='
WHERE
key_id = '9fc6aba2bd720d2d89929826810ee0e6d58a0b7f991ccc9ee077e9e63e56c8c0'
AND (
token = 'zbCTkbEfulOWXo2q249bpGb3T2MParuTh4skBZkNUGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)