UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jiPHAdokEIcHGOfG6qlsQBpoBzs4heSoTM1NQSo45uU='
WHERE
key_id = '2c45a1516a62b899e80cca63f16381262f10e7fcf41cc5f564021f503da6d0d0'
AND (
token = 'jiPHAdokEIcHGOfG6qlsQBpoBzs4heSoTM1NQSo45uU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)