UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OdK56wZ9KO+yxBIG+sF/pBq8qME1PBS9ksCbrTqAE88='
WHERE
key_id = '818c82639df37e2bc861ee6a3973105f0841e9ecb4ee0f5a6650c66caced0776'
AND (
token = 'OdK56wZ9KO+yxBIG+sF/pBq8qME1PBS9ksCbrTqAE88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)