UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qhOsrxrK3npdqdlhAravPEExMgoxfCOYXBCXRFv/OS4='
WHERE
key_id = 'bff3253fe30b45944c2c72dfb1a0ab9d8000d4968ce0cf218462d995c5270e29'
AND (
token = 'qhOsrxrK3npdqdlhAravPEExMgoxfCOYXBCXRFv/OS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)