UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2avhIS2a5TEQBC7laCdt9T7Dt3GTQtrh6m8z4e/SEZg='
WHERE
key_id = 'cd197c9cdddcfee22257c3f54be2dffa505b4a6a518fb56c15e2cbb41ffc2398'
AND (
token = '2avhIS2a5TEQBC7laCdt9T7Dt3GTQtrh6m8z4e/SEZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)