UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCRFug+G8BEYjtP2edxGH4/sKqAJNWgCA+LNmNk1Y6c='
WHERE
key_id = '4efc6cf0a2cb2b11cd6585599c904a7c0985326f12971a7d174849a58b603e7a'
AND (
token = 'zCRFug+G8BEYjtP2edxGH4/sKqAJNWgCA+LNmNk1Y6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)