UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xH4jw8f8kuS767pXyI1PU3c6RQMz2NLVIdmIaCXHYUg='
WHERE
key_id = 'c4b0a9a55258075cac04cf2443bc7c0c28a3c6d8c5ca5701fb726c9bb578e352'
AND (
token = 'xH4jw8f8kuS767pXyI1PU3c6RQMz2NLVIdmIaCXHYUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)