UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vzLQpM5jWUJgibD857zbRsy8EniTfRVPTcZdaoc7er4='
WHERE
key_id = '2754165b9326f5c6e6ffaa28b4c319500c739e1df61e5a1e03211ed1bd0f23ca'
AND (
token = 'vzLQpM5jWUJgibD857zbRsy8EniTfRVPTcZdaoc7er4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)