UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DPdIN3cjTaSmFLtrPLRVvxuQzF6kt7jeh2RbtIcWKe8='
WHERE
key_id = '18b291bc86a3c9c5ab0e912967460ca56c13859e5bdcb8780c3010fda5db3fee'
AND (
token = 'DPdIN3cjTaSmFLtrPLRVvxuQzF6kt7jeh2RbtIcWKe8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)