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