UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6LfjYlk43eP6ZQa9/zt+EAPMhaMzAus0wxe7y6lMvqI='
WHERE
key_id = '004fa8fceb445d63f09bf823b5890d441a608891ef52564c6d1fce958a25714d'
AND (
token = '6LfjYlk43eP6ZQa9/zt+EAPMhaMzAus0wxe7y6lMvqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)