UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VDkIsjx1vdprIQNHN0X624dIB5w2HPYTWBqXu+szgtw='
WHERE
key_id = 'b17dcd2691797438e6228a29949a3c0a7af2c53c41928499cdc7d8e9a4fbd465'
AND (
token = 'VDkIsjx1vdprIQNHN0X624dIB5w2HPYTWBqXu+szgtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)