UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzuIMt+L231JwC6MP3usWXkEDgwXXcie87KpM+esigk='
WHERE
key_id = '1e59d3e7c8da2791e6400630e0354bb3ba28457fc5adaf815224caf0bc86754a'
AND (
token = 'VzuIMt+L231JwC6MP3usWXkEDgwXXcie87KpM+esigk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)