UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VD3sohJe5ej7i7N2/tT35b0VsKDotuNSbN9gHgQ4jy4='
WHERE
key_id = '1972594ff84921239bd71ff0a41ba344d50c7cac4dd400acef235277355bb5be'
AND (
token = 'VD3sohJe5ej7i7N2/tT35b0VsKDotuNSbN9gHgQ4jy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)