UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8YnpQ+wxLFf266qSDvgXidxDfUKAboeyIC0M5BYiHuk='
WHERE
key_id = 'bfc19f72f8b3cd56889b5335b827c1b492ff69746f5d715dc6242701b8a548fe'
AND (
token = '8YnpQ+wxLFf266qSDvgXidxDfUKAboeyIC0M5BYiHuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)