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