UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w7IcBEWU96cMJBholUsA0AYfN9sh4nrYT6pY/EaDtys='
WHERE
key_id = '7a1a0098fdffad514998f0f272c8b3f00457ab152a3dcb6f39b4c9d905687268'
AND (
token = 'w7IcBEWU96cMJBholUsA0AYfN9sh4nrYT6pY/EaDtys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)