UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6NwbKagAcroY0mw5cUUG47N3SU3znbOBL9edLY5XaG8='
WHERE
key_id = '711a52047f591e75422a0c0bec3207783d5999f1dae2600a9f1ae9315a52bdc0'
AND (
token = '6NwbKagAcroY0mw5cUUG47N3SU3znbOBL9edLY5XaG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)