UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mrn+nTTr3fnMyBHAZhmEYYFgzSFWziF4GxHkv99QfUY='
WHERE
key_id = '189276b94311f926fe9b797e1d8ff5076111bcd84456f4fbd180a1ab9ffec438'
AND (
token = 'mrn+nTTr3fnMyBHAZhmEYYFgzSFWziF4GxHkv99QfUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)