UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEmfYmLYOsQBAVLN9FWave+hyhh1zqxjqTYo3KBdqVE='
WHERE
key_id = '19346b9313a6624b4d8655181d08e0e36d96c79f2cb2baf9d8a375c4025c3550'
AND (
token = 'XEmfYmLYOsQBAVLN9FWave+hyhh1zqxjqTYo3KBdqVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)