UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0yvtAzwb3WfqIXPu39fXAg3lhz6tDVIdq7HBdZwVinI='
WHERE
key_id = '1ceaea3d71a4527b3122e6ddb18e0a143ae8c4d07e7bd179bc6d8ce711ebeb88'
AND (
token = '0yvtAzwb3WfqIXPu39fXAg3lhz6tDVIdq7HBdZwVinI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)