UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OMkW0dGfpc2EOM6NDhLL2vR27WpM7wp4R23pyRiMGDk='
WHERE
key_id = '4918e3ca311de0df066b35b43f4b8eef1c8102a58909e6ec35e07d298704846f'
AND (
token = 'OMkW0dGfpc2EOM6NDhLL2vR27WpM7wp4R23pyRiMGDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)