UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G18exxoBsYwT1VBHiaCIGUM4mcI2ayfyGCa5paDVngU='
WHERE
key_id = '281c7b1bf34270bceee5977d01b89632584e5d19bf57c40e3530c994249615e8'
AND (
token = 'G18exxoBsYwT1VBHiaCIGUM4mcI2ayfyGCa5paDVngU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)