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