UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ia8J5Q5TyU8/+A2TwtF0iR8tlyTburNFM51XCShpi0c='
WHERE
key_id = '47446a430b6f3999f20ccfa30612415801bc3e8c99b393cb82859626cae866fe'
AND (
token = 'Ia8J5Q5TyU8/+A2TwtF0iR8tlyTburNFM51XCShpi0c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)