UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OcIFoNaCqnvnhInvWVBknLY5gMt3ceFVqG2qGER3oRQ='
WHERE
key_id = '6529a38f2248bfb18fafb2aca015895e82e83c2b1ee3e77d295d551171694386'
AND (
token = 'OcIFoNaCqnvnhInvWVBknLY5gMt3ceFVqG2qGER3oRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)