UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RGCJYnglFnSw6lqZK7YLArmktxA1mYmnqAHPu5D4cdA='
WHERE
key_id = '9c04276dc13fdd2cb75f0a2460bb66e6a35f5f752bea66afa78d8db6e37e2e79'
AND (
token = 'RGCJYnglFnSw6lqZK7YLArmktxA1mYmnqAHPu5D4cdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)