UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X6b0OW6ghayGDW1XhL58W8aEimOFqIKb8gW6hkZ8OEQ='
WHERE
key_id = 'e570968dc4d78930fe143c843e2196fbea5e5cd8cdbf07a29d4cab9f785bc704'
AND (
token = 'X6b0OW6ghayGDW1XhL58W8aEimOFqIKb8gW6hkZ8OEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)