UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ht2EcAM9pBdzPhNlmSOevjLRBc0VwKxHb7SzJSeKbs='
WHERE
key_id = '5d7ccbb0dd21639093987aa201231180eedc7b6f88c6b5ebdef6c5629c9e196b'
AND (
token = '1ht2EcAM9pBdzPhNlmSOevjLRBc0VwKxHb7SzJSeKbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)