UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4BAanxZgxcYW2lZcO977/tqPLaAcCpsNIPME4AoE6ik='
WHERE
key_id = 'c4ea0721307ae8af52115828ba9534a70778515ff1aa26cdc88523f78e182307'
AND (
token = '4BAanxZgxcYW2lZcO977/tqPLaAcCpsNIPME4AoE6ik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)