UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LTYm5abRiCQI4RqZ3c+E0HEmJdYpONa3og+ZvlA95II='
WHERE
key_id = '74a569172204187185207892a7e8a3614520e0caee9e4147a54759b6a300c361'
AND (
token = 'LTYm5abRiCQI4RqZ3c+E0HEmJdYpONa3og+ZvlA95II='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)