UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DKx1zYTYcaTfkyFi4Fso94OoFKApseihqJggKBpV8r0='
WHERE
key_id = 'd93b1738cfe2c52aa3bedfe541c4e9dc55a957a979f331d73e69f8b33a08c601'
AND (
token = 'DKx1zYTYcaTfkyFi4Fso94OoFKApseihqJggKBpV8r0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)