UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gp9DJF+EKXz32S2HTC7bbLl+U8yeR9ffY0LQi+711g='
WHERE
key_id = 'a8cfce98c4af3a65ca4dbeb16b1cfddf300e23415803daf00fee3798525f3c40'
AND (
token = '6gp9DJF+EKXz32S2HTC7bbLl+U8yeR9ffY0LQi+711g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)