UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XUYJ2CkbE96IPmLr5m1IOSCK/1yd7CbLxRVQnF5O3MY='
WHERE
key_id = '7922ef53c7f9657f2277717d7934bb248075c6022b248528284b9d111064a8ac'
AND (
token = 'XUYJ2CkbE96IPmLr5m1IOSCK/1yd7CbLxRVQnF5O3MY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)