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