UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9jgm89PjGJY34kjlxPI1vT5q88yXcq8AYPGW01MSfW8='
WHERE
key_id = '1c45c8907adbce60f8ee82ab6174ca3a9bb2c40c4af5df699ed1e52aacd95666'
AND (
token = '9jgm89PjGJY34kjlxPI1vT5q88yXcq8AYPGW01MSfW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)