UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HBtvGb5uUn1sEp78a2IPmIByZ51YX2j0e0XS8XCZTwY='
WHERE
key_id = 'db4ac859db8effd6ac3fcc75912ae5d2c00424c9d98650a5d5af1c93975c85b6'
AND (
token = 'HBtvGb5uUn1sEp78a2IPmIByZ51YX2j0e0XS8XCZTwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)