UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aiRfUhBIqM4TTNFstFZNuDHsK2Gc7tMBzY3g5evQPdQ='
WHERE
key_id = '7db4d9a914036bdaea4669d00bd577ecd4195842c827dc8918b838ab69bc4cba'
AND (
token = 'aiRfUhBIqM4TTNFstFZNuDHsK2Gc7tMBzY3g5evQPdQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)